IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UnresolvedMSSQLInstnc]') AND type in (N'U'))
BEGIN
     DROP TABLE [dbo].[UnresolvedMSSQLInstnc]
END
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[UnresolvedMSSQLInstnc](
     [UnresolvedMSSQLInstncId] [int] IDENTITY(1,1) NOT NULL,
     [PackageExecutionId]      [bigint]            NOT NULL,
     [FullInstanceName]        [varchar](255)      NOT NULL,
     [MachineName]             [varchar](128)      NOT NULL,
     [InstanceName]            [varchar](128)      NOT NULL,
     [LoginName]               [varchar](128)      NOT NULL,
     [ServiceRunningFlag]      [int]               NOT NULL,
     [IsClusteredFlag]         [int]                   NULL,
     [ErrorDesc]               [varchar](255)          NULL,
     CONSTRAINT [PK_UnresolvedMSSQLInstnc] PRIMARY KEY CLUSTERED ( [UnresolvedMSSQLInstncId] ASC, [FullInstanceName] ASC )
) ON [PRIMARY]
GO

SET ANSI_PADDING OFF
GO
